package meterMonitor.mapper;

import meterMonitor.model.MonitorHour;
import meterMonitor.vo.MonitorMeter;
import meterMonitor.vo.QueryForChartRequest;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface MonitorHourMapper {
    int deleteByPrimaryKey(Long pkid);

    int insert(MonitorHour record);

    int insertSelective(MonitorHour record);

    MonitorHour selectByPrimaryKey(Long pkid);

    //综合
    List<MonitorHour> queryForCharts(QueryForChartRequest requestMod);
    //图表
    List<MonitorMeter> queryForDay(QueryForChartRequest requestMod);

    //图表日报
    List<MonitorMeter> queryForOneDay(QueryForChartRequest requestMod);

    int updateByPrimaryKeySelective(MonitorHour record);

    int updateByPrimaryKey(MonitorHour record);

    //根据上传日期和所属时段查询某日期对应时间段的用水量
    double selectEveryHourWater(@Param(value = "uploadDate") String uploadDate, @Param(value = "ownerTimer") String ownerTimer);
}